This unit describes the skills and knowledge required to retrieve and manipulate information stored in information systems, using a query language.

It applies to individuals in a range of work environments, who are required to extract information from a source such as a database, a text file, or an extensible markup language (XML), by creating and running queries.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

ELEMENT	PERFORMANCE CRITERIA
Elements describe the essential outcomes.	Performance criteria describe the performance needed to demonstrate achievement of the element.
1. Determine the requirements of developing queries	1.1 Recognise various query-related terminologies 1.2 Identify the type of data source for a chosen query language 1.3 Identify and use the necessary tools, and environment, in building queries
2. Write queries to retrieve and sort values	2.1 Use an expression to retrieve values from a single unit 2.2 Use an expression to combine values from more than one unit 2.3 Use an expression to sort values into a certain order
3. Write queries to selectively retrieve values	3.1 Use an expression to filter a sequence, based on a predicate or a condition 3.2 Use an expression to filter the subset of a sequence, based on a predicate or a condition 3.3 Use an expression to extract a specific value by position
4. Perform a calculation in queries	4.1 Use an expression to perform a calculation on numeric values 4.2 Use an expression to perform an operation on text values 4.3 Use an expression to perform an operation on date and time values

Evidence of the ability to:

select and use tools in developing, storing, and executing queries to extract the appropriate data required for ad hoc reports, or to support developers

incorporate calculations using control statements, operators and functions.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

outline the information gathering methods

outline the data analysis techniques

define data mining

outline the characteristics of the data source

explain the features of the information system

explain typical systems and procedures.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development industry, and include access to:

a data source

resources in the chosen query language

documentation regarding client and functionality requirements

resources to aid calculation.

Assessors must satisfy NVR/AQTF assessor requirements.

List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

ELEMENT	PERFORMANCE CRITERIA
Elements describe the essential outcomes.	Performance criteria describe the performance needed to demonstrate achievement of the element.
1. Determine the requirements of developing queries	1.1 Recognise various query-related terminologies 1.2 Identify the type of data source for a chosen query language 1.3 Identify and use the necessary tools, and environment, in building queries
2. Write queries to retrieve and sort values	2.1 Use an expression to retrieve values from a single unit 2.2 Use an expression to combine values from more than one unit 2.3 Use an expression to sort values into a certain order
3. Write queries to selectively retrieve values	3.1 Use an expression to filter a sequence, based on a predicate or a condition 3.2 Use an expression to filter the subset of a sequence, based on a predicate or a condition 3.3 Use an expression to extract a specific value by position
4. Perform a calculation in queries	4.1 Use an expression to perform a calculation on numeric values 4.2 Use an expression to perform an operation on text values 4.3 Use an expression to perform an operation on date and time values

Evidence of the ability to:

select and use tools in developing, storing, and executing queries to extract the appropriate data required for ad hoc reports, or to support developers

incorporate calculations using control statements, operators and functions.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

outline the information gathering methods

outline the data analysis techniques

define data mining

outline the characteristics of the data source

explain the features of the information system

explain typical systems and procedures.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development industry, and include access to:

a data source

resources in the chosen query language

documentation regarding client and functionality requirements

resources to aid calculation.

Assessors must satisfy NVR/AQTF assessor requirements.

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice	Yes	No	Comments/feedback
Recognise various query-related terminologies
Identify the type of data source for a chosen query language
Identify and use the necessary tools, and environment, in building queries
Use an expression to retrieve values from a single unit
Use an expression to combine values from more than one unit
Use an expression to sort values into a certain order
Use an expression to filter a sequence, based on a predicate or a condition
Use an expression to filter the subset of a sequence, based on a predicate or a condition
Use an expression to extract a specific value by position
Use an expression to perform a calculation on numeric values
Use an expression to perform an operation on text values
Use an expression to perform an operation on date and time values

Assessment Cover Sheet

ICTPRG402 - Apply query language

Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTPRG402 - Apply query language

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: